<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Qtree details</title>
</head>
<style type="text/css">
@import "flip-tabs.css";
</style>
<script type="text/javascript" src="flip-tab.js">
</script>
<script type="text/javascript">
  document.write('<style type="text/css">');  
  document.write('div.flip-tabs div{display:none;}<');
  document.write('/s'+'tyle>'); </script>

</head>
<body style="background-color:darkseagreen;">
 <image align="right" src=Capture.jpg width=100 height=100 font size=4 color=black>
<h1 align="center"><font color=blue>STORAGE INVENTORY</font></h1>


 <table cellpadding=6 border=2 width=750>
  


<div id="flip-tabs">
        <ul id="flip-navigation">

             <li> <a href="Aggregade.jsp" id="tab-2">Aggregade Details</a> </li>
         	<li> <a href="Disk.jsp" id="tab-5">Disk Details</a> </li>
     	 	<li> <a href="vol.jsp" id="tab-1">volume Details</a> </li>
      		<li><a href="lun.jsp" id="tab-3">Lun Details</a> </li>
      		<li> <a href="Qtree.jsp" id="tab-4">Qtree Details</a> </li>
            <li> <a href="HomePage.jsp" id="tab-6">Home</a> </li>
   
    </ul>
    <div id="flip-container">
    </div>
    
 </div> 


 
   
   
  <tr>
  <th bgcolor="#5D7B9D"><font color="#fff">volname</font></th>
  <th bgcolor="#5D7B9D"><font color="#fff"> tree</font></th>
  <th bgcolor="#5D7B9D"><font color="#fff">NFS_OPS</font></th>
   <th bgcolor="#5D7B9D"><font color="#fff">CIFS_OPS</font></th>
   </tr>
  
  <font size="4" color="blue">Qtree Details</font> 
 <%@ page import= "java.sql.*;"%>
<%  Connection con=null;
      Statement st=null;
     
      ResultSet rs=null;
      PreparedStatement pt=null;
      
 
	String volname,tree,NFS_OPS,CIFS_OPS;
try
	{
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	con = DriverManager.getConnection("jdbc:mysql://localhost/netapp", "root", "rr");
	
	
                pt=con.prepareStatement("select * from qtree");
	  rs=pt.executeQuery();
              while( rs.next())
	  {
	  volname=rs.getString(1);
	  tree=rs.getString(2);
	  NFS_OPS=rs.getString(3);
	 
	  CIFS_OPS=rs.getString(4);

	 

	  
	  out.println("<TR>");
     
    		  out.println("<TD>"+"<image src=1.jpg width=10 height=10 font size=4 color=blue>  " + volname +"</font>"+ "</TD>");
      		  out.println("<TD>"+"<image src=1.jpg width=10 height=10font size=4 color=blue>  " + tree +"</font>"+ "</TD>");
              out.println("<TD>"+"<image src=1.jpg width=10 height=10 font size=4 color=black>  " + NFS_OPS +"</font>"+ "</TD>");
              out.println("<TD>"+"<image src=1.jpg width=10 height=10 size=4 color=black>  " + CIFS_OPS +"</font>"+ "</TD>");
     
      out.println("</TR>");

	  
     
	  
	}
              }
catch(Exception e)
{
 	out.println(e);
}
%>
 </TABLE>;



</body>
</html>